package com.desksoft.ecommerce.entity.mall.dto;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class SalepromlistExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public SalepromlistExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andBilldateIsNull() {
            addCriterion("BillDate is null");
            return (Criteria) this;
        }

        public Criteria andBilldateIsNotNull() {
            addCriterion("BillDate is not null");
            return (Criteria) this;
        }

        public Criteria andBilldateEqualTo(Date value) {
            addCriterion("BillDate =", value, "billdate");
            return (Criteria) this;
        }

        public Criteria andBilldateNotEqualTo(Date value) {
            addCriterion("BillDate <>", value, "billdate");
            return (Criteria) this;
        }

        public Criteria andBilldateGreaterThan(Date value) {
            addCriterion("BillDate >", value, "billdate");
            return (Criteria) this;
        }

        public Criteria andBilldateGreaterThanOrEqualTo(Date value) {
            addCriterion("BillDate >=", value, "billdate");
            return (Criteria) this;
        }

        public Criteria andBilldateLessThan(Date value) {
            addCriterion("BillDate <", value, "billdate");
            return (Criteria) this;
        }

        public Criteria andBilldateLessThanOrEqualTo(Date value) {
            addCriterion("BillDate <=", value, "billdate");
            return (Criteria) this;
        }

        public Criteria andBilldateIn(List<Date> values) {
            addCriterion("BillDate in", values, "billdate");
            return (Criteria) this;
        }

        public Criteria andBilldateNotIn(List<Date> values) {
            addCriterion("BillDate not in", values, "billdate");
            return (Criteria) this;
        }

        public Criteria andBilldateBetween(Date value1, Date value2) {
            addCriterion("BillDate between", value1, value2, "billdate");
            return (Criteria) this;
        }

        public Criteria andBilldateNotBetween(Date value1, Date value2) {
            addCriterion("BillDate not between", value1, value2, "billdate");
            return (Criteria) this;
        }

        public Criteria andBillnoIsNull() {
            addCriterion("BillNo is null");
            return (Criteria) this;
        }

        public Criteria andBillnoIsNotNull() {
            addCriterion("BillNo is not null");
            return (Criteria) this;
        }

        public Criteria andBillnoEqualTo(String value) {
            addCriterion("BillNo =", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoNotEqualTo(String value) {
            addCriterion("BillNo <>", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoGreaterThan(String value) {
            addCriterion("BillNo >", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoGreaterThanOrEqualTo(String value) {
            addCriterion("BillNo >=", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoLessThan(String value) {
            addCriterion("BillNo <", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoLessThanOrEqualTo(String value) {
            addCriterion("BillNo <=", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoLike(String value) {
            addCriterion("BillNo like", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoNotLike(String value) {
            addCriterion("BillNo not like", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoIn(List<String> values) {
            addCriterion("BillNo in", values, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoNotIn(List<String> values) {
            addCriterion("BillNo not in", values, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoBetween(String value1, String value2) {
            addCriterion("BillNo between", value1, value2, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoNotBetween(String value1, String value2) {
            addCriterion("BillNo not between", value1, value2, "billno");
            return (Criteria) this;
        }

        public Criteria andDccodeIsNull() {
            addCriterion("DCCode is null");
            return (Criteria) this;
        }

        public Criteria andDccodeIsNotNull() {
            addCriterion("DCCode is not null");
            return (Criteria) this;
        }

        public Criteria andDccodeEqualTo(String value) {
            addCriterion("DCCode =", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeNotEqualTo(String value) {
            addCriterion("DCCode <>", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeGreaterThan(String value) {
            addCriterion("DCCode >", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeGreaterThanOrEqualTo(String value) {
            addCriterion("DCCode >=", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeLessThan(String value) {
            addCriterion("DCCode <", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeLessThanOrEqualTo(String value) {
            addCriterion("DCCode <=", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeLike(String value) {
            addCriterion("DCCode like", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeNotLike(String value) {
            addCriterion("DCCode not like", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeIn(List<String> values) {
            addCriterion("DCCode in", values, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeNotIn(List<String> values) {
            addCriterion("DCCode not in", values, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeBetween(String value1, String value2) {
            addCriterion("DCCode between", value1, value2, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeNotBetween(String value1, String value2) {
            addCriterion("DCCode not between", value1, value2, "dccode");
            return (Criteria) this;
        }

        public Criteria andItemcodeIsNull() {
            addCriterion("ItemCode is null");
            return (Criteria) this;
        }

        public Criteria andItemcodeIsNotNull() {
            addCriterion("ItemCode is not null");
            return (Criteria) this;
        }

        public Criteria andItemcodeEqualTo(String value) {
            addCriterion("ItemCode =", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeNotEqualTo(String value) {
            addCriterion("ItemCode <>", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeGreaterThan(String value) {
            addCriterion("ItemCode >", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeGreaterThanOrEqualTo(String value) {
            addCriterion("ItemCode >=", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeLessThan(String value) {
            addCriterion("ItemCode <", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeLessThanOrEqualTo(String value) {
            addCriterion("ItemCode <=", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeLike(String value) {
            addCriterion("ItemCode like", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeNotLike(String value) {
            addCriterion("ItemCode not like", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeIn(List<String> values) {
            addCriterion("ItemCode in", values, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeNotIn(List<String> values) {
            addCriterion("ItemCode not in", values, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeBetween(String value1, String value2) {
            addCriterion("ItemCode between", value1, value2, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeNotBetween(String value1, String value2) {
            addCriterion("ItemCode not between", value1, value2, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemtypeIsNull() {
            addCriterion("ItemType is null");
            return (Criteria) this;
        }

        public Criteria andItemtypeIsNotNull() {
            addCriterion("ItemType is not null");
            return (Criteria) this;
        }

        public Criteria andItemtypeEqualTo(String value) {
            addCriterion("ItemType =", value, "itemtype");
            return (Criteria) this;
        }

        public Criteria andItemtypeNotEqualTo(String value) {
            addCriterion("ItemType <>", value, "itemtype");
            return (Criteria) this;
        }

        public Criteria andItemtypeGreaterThan(String value) {
            addCriterion("ItemType >", value, "itemtype");
            return (Criteria) this;
        }

        public Criteria andItemtypeGreaterThanOrEqualTo(String value) {
            addCriterion("ItemType >=", value, "itemtype");
            return (Criteria) this;
        }

        public Criteria andItemtypeLessThan(String value) {
            addCriterion("ItemType <", value, "itemtype");
            return (Criteria) this;
        }

        public Criteria andItemtypeLessThanOrEqualTo(String value) {
            addCriterion("ItemType <=", value, "itemtype");
            return (Criteria) this;
        }

        public Criteria andItemtypeLike(String value) {
            addCriterion("ItemType like", value, "itemtype");
            return (Criteria) this;
        }

        public Criteria andItemtypeNotLike(String value) {
            addCriterion("ItemType not like", value, "itemtype");
            return (Criteria) this;
        }

        public Criteria andItemtypeIn(List<String> values) {
            addCriterion("ItemType in", values, "itemtype");
            return (Criteria) this;
        }

        public Criteria andItemtypeNotIn(List<String> values) {
            addCriterion("ItemType not in", values, "itemtype");
            return (Criteria) this;
        }

        public Criteria andItemtypeBetween(String value1, String value2) {
            addCriterion("ItemType between", value1, value2, "itemtype");
            return (Criteria) this;
        }

        public Criteria andItemtypeNotBetween(String value1, String value2) {
            addCriterion("ItemType not between", value1, value2, "itemtype");
            return (Criteria) this;
        }

        public Criteria andR00201IsNull() {
            addCriterion("R00201 is null");
            return (Criteria) this;
        }

        public Criteria andR00201IsNotNull() {
            addCriterion("R00201 is not null");
            return (Criteria) this;
        }

        public Criteria andR00201EqualTo(String value) {
            addCriterion("R00201 =", value, "r00201");
            return (Criteria) this;
        }

        public Criteria andR00201NotEqualTo(String value) {
            addCriterion("R00201 <>", value, "r00201");
            return (Criteria) this;
        }

        public Criteria andR00201GreaterThan(String value) {
            addCriterion("R00201 >", value, "r00201");
            return (Criteria) this;
        }

        public Criteria andR00201GreaterThanOrEqualTo(String value) {
            addCriterion("R00201 >=", value, "r00201");
            return (Criteria) this;
        }

        public Criteria andR00201LessThan(String value) {
            addCriterion("R00201 <", value, "r00201");
            return (Criteria) this;
        }

        public Criteria andR00201LessThanOrEqualTo(String value) {
            addCriterion("R00201 <=", value, "r00201");
            return (Criteria) this;
        }

        public Criteria andR00201Like(String value) {
            addCriterion("R00201 like", value, "r00201");
            return (Criteria) this;
        }

        public Criteria andR00201NotLike(String value) {
            addCriterion("R00201 not like", value, "r00201");
            return (Criteria) this;
        }

        public Criteria andR00201In(List<String> values) {
            addCriterion("R00201 in", values, "r00201");
            return (Criteria) this;
        }

        public Criteria andR00201NotIn(List<String> values) {
            addCriterion("R00201 not in", values, "r00201");
            return (Criteria) this;
        }

        public Criteria andR00201Between(String value1, String value2) {
            addCriterion("R00201 between", value1, value2, "r00201");
            return (Criteria) this;
        }

        public Criteria andR00201NotBetween(String value1, String value2) {
            addCriterion("R00201 not between", value1, value2, "r00201");
            return (Criteria) this;
        }

        public Criteria andStorecodeIsNull() {
            addCriterion("StoreCode is null");
            return (Criteria) this;
        }

        public Criteria andStorecodeIsNotNull() {
            addCriterion("StoreCode is not null");
            return (Criteria) this;
        }

        public Criteria andStorecodeEqualTo(String value) {
            addCriterion("StoreCode =", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotEqualTo(String value) {
            addCriterion("StoreCode <>", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeGreaterThan(String value) {
            addCriterion("StoreCode >", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeGreaterThanOrEqualTo(String value) {
            addCriterion("StoreCode >=", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeLessThan(String value) {
            addCriterion("StoreCode <", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeLessThanOrEqualTo(String value) {
            addCriterion("StoreCode <=", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeLike(String value) {
            addCriterion("StoreCode like", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotLike(String value) {
            addCriterion("StoreCode not like", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeIn(List<String> values) {
            addCriterion("StoreCode in", values, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotIn(List<String> values) {
            addCriterion("StoreCode not in", values, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeBetween(String value1, String value2) {
            addCriterion("StoreCode between", value1, value2, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotBetween(String value1, String value2) {
            addCriterion("StoreCode not between", value1, value2, "storecode");
            return (Criteria) this;
        }

        public Criteria andClienttypeIsNull() {
            addCriterion("ClientType is null");
            return (Criteria) this;
        }

        public Criteria andClienttypeIsNotNull() {
            addCriterion("ClientType is not null");
            return (Criteria) this;
        }

        public Criteria andClienttypeEqualTo(String value) {
            addCriterion("ClientType =", value, "clienttype");
            return (Criteria) this;
        }

        public Criteria andClienttypeNotEqualTo(String value) {
            addCriterion("ClientType <>", value, "clienttype");
            return (Criteria) this;
        }

        public Criteria andClienttypeGreaterThan(String value) {
            addCriterion("ClientType >", value, "clienttype");
            return (Criteria) this;
        }

        public Criteria andClienttypeGreaterThanOrEqualTo(String value) {
            addCriterion("ClientType >=", value, "clienttype");
            return (Criteria) this;
        }

        public Criteria andClienttypeLessThan(String value) {
            addCriterion("ClientType <", value, "clienttype");
            return (Criteria) this;
        }

        public Criteria andClienttypeLessThanOrEqualTo(String value) {
            addCriterion("ClientType <=", value, "clienttype");
            return (Criteria) this;
        }

        public Criteria andClienttypeLike(String value) {
            addCriterion("ClientType like", value, "clienttype");
            return (Criteria) this;
        }

        public Criteria andClienttypeNotLike(String value) {
            addCriterion("ClientType not like", value, "clienttype");
            return (Criteria) this;
        }

        public Criteria andClienttypeIn(List<String> values) {
            addCriterion("ClientType in", values, "clienttype");
            return (Criteria) this;
        }

        public Criteria andClienttypeNotIn(List<String> values) {
            addCriterion("ClientType not in", values, "clienttype");
            return (Criteria) this;
        }

        public Criteria andClienttypeBetween(String value1, String value2) {
            addCriterion("ClientType between", value1, value2, "clienttype");
            return (Criteria) this;
        }

        public Criteria andClienttypeNotBetween(String value1, String value2) {
            addCriterion("ClientType not between", value1, value2, "clienttype");
            return (Criteria) this;
        }

        public Criteria andClientcodeIsNull() {
            addCriterion("ClientCode is null");
            return (Criteria) this;
        }

        public Criteria andClientcodeIsNotNull() {
            addCriterion("ClientCode is not null");
            return (Criteria) this;
        }

        public Criteria andClientcodeEqualTo(String value) {
            addCriterion("ClientCode =", value, "clientcode");
            return (Criteria) this;
        }

        public Criteria andClientcodeNotEqualTo(String value) {
            addCriterion("ClientCode <>", value, "clientcode");
            return (Criteria) this;
        }

        public Criteria andClientcodeGreaterThan(String value) {
            addCriterion("ClientCode >", value, "clientcode");
            return (Criteria) this;
        }

        public Criteria andClientcodeGreaterThanOrEqualTo(String value) {
            addCriterion("ClientCode >=", value, "clientcode");
            return (Criteria) this;
        }

        public Criteria andClientcodeLessThan(String value) {
            addCriterion("ClientCode <", value, "clientcode");
            return (Criteria) this;
        }

        public Criteria andClientcodeLessThanOrEqualTo(String value) {
            addCriterion("ClientCode <=", value, "clientcode");
            return (Criteria) this;
        }

        public Criteria andClientcodeLike(String value) {
            addCriterion("ClientCode like", value, "clientcode");
            return (Criteria) this;
        }

        public Criteria andClientcodeNotLike(String value) {
            addCriterion("ClientCode not like", value, "clientcode");
            return (Criteria) this;
        }

        public Criteria andClientcodeIn(List<String> values) {
            addCriterion("ClientCode in", values, "clientcode");
            return (Criteria) this;
        }

        public Criteria andClientcodeNotIn(List<String> values) {
            addCriterion("ClientCode not in", values, "clientcode");
            return (Criteria) this;
        }

        public Criteria andClientcodeBetween(String value1, String value2) {
            addCriterion("ClientCode between", value1, value2, "clientcode");
            return (Criteria) this;
        }

        public Criteria andClientcodeNotBetween(String value1, String value2) {
            addCriterion("ClientCode not between", value1, value2, "clientcode");
            return (Criteria) this;
        }

        public Criteria andR00202IsNull() {
            addCriterion("R00202 is null");
            return (Criteria) this;
        }

        public Criteria andR00202IsNotNull() {
            addCriterion("R00202 is not null");
            return (Criteria) this;
        }

        public Criteria andR00202EqualTo(String value) {
            addCriterion("R00202 =", value, "r00202");
            return (Criteria) this;
        }

        public Criteria andR00202NotEqualTo(String value) {
            addCriterion("R00202 <>", value, "r00202");
            return (Criteria) this;
        }

        public Criteria andR00202GreaterThan(String value) {
            addCriterion("R00202 >", value, "r00202");
            return (Criteria) this;
        }

        public Criteria andR00202GreaterThanOrEqualTo(String value) {
            addCriterion("R00202 >=", value, "r00202");
            return (Criteria) this;
        }

        public Criteria andR00202LessThan(String value) {
            addCriterion("R00202 <", value, "r00202");
            return (Criteria) this;
        }

        public Criteria andR00202LessThanOrEqualTo(String value) {
            addCriterion("R00202 <=", value, "r00202");
            return (Criteria) this;
        }

        public Criteria andR00202Like(String value) {
            addCriterion("R00202 like", value, "r00202");
            return (Criteria) this;
        }

        public Criteria andR00202NotLike(String value) {
            addCriterion("R00202 not like", value, "r00202");
            return (Criteria) this;
        }

        public Criteria andR00202In(List<String> values) {
            addCriterion("R00202 in", values, "r00202");
            return (Criteria) this;
        }

        public Criteria andR00202NotIn(List<String> values) {
            addCriterion("R00202 not in", values, "r00202");
            return (Criteria) this;
        }

        public Criteria andR00202Between(String value1, String value2) {
            addCriterion("R00202 between", value1, value2, "r00202");
            return (Criteria) this;
        }

        public Criteria andR00202NotBetween(String value1, String value2) {
            addCriterion("R00202 not between", value1, value2, "r00202");
            return (Criteria) this;
        }

        public Criteria andPromamtIsNull() {
            addCriterion("PromAmt is null");
            return (Criteria) this;
        }

        public Criteria andPromamtIsNotNull() {
            addCriterion("PromAmt is not null");
            return (Criteria) this;
        }

        public Criteria andPromamtEqualTo(BigDecimal value) {
            addCriterion("PromAmt =", value, "promamt");
            return (Criteria) this;
        }

        public Criteria andPromamtNotEqualTo(BigDecimal value) {
            addCriterion("PromAmt <>", value, "promamt");
            return (Criteria) this;
        }

        public Criteria andPromamtGreaterThan(BigDecimal value) {
            addCriterion("PromAmt >", value, "promamt");
            return (Criteria) this;
        }

        public Criteria andPromamtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("PromAmt >=", value, "promamt");
            return (Criteria) this;
        }

        public Criteria andPromamtLessThan(BigDecimal value) {
            addCriterion("PromAmt <", value, "promamt");
            return (Criteria) this;
        }

        public Criteria andPromamtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("PromAmt <=", value, "promamt");
            return (Criteria) this;
        }

        public Criteria andPromamtIn(List<BigDecimal> values) {
            addCriterion("PromAmt in", values, "promamt");
            return (Criteria) this;
        }

        public Criteria andPromamtNotIn(List<BigDecimal> values) {
            addCriterion("PromAmt not in", values, "promamt");
            return (Criteria) this;
        }

        public Criteria andPromamtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PromAmt between", value1, value2, "promamt");
            return (Criteria) this;
        }

        public Criteria andPromamtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PromAmt not between", value1, value2, "promamt");
            return (Criteria) this;
        }

        public Criteria andSysdateIsNull() {
            addCriterion("SysDate is null");
            return (Criteria) this;
        }

        public Criteria andSysdateIsNotNull() {
            addCriterion("SysDate is not null");
            return (Criteria) this;
        }

        public Criteria andSysdateEqualTo(Date value) {
            addCriterion("SysDate =", value, "sysdate");
            return (Criteria) this;
        }

        public Criteria andSysdateNotEqualTo(Date value) {
            addCriterion("SysDate <>", value, "sysdate");
            return (Criteria) this;
        }

        public Criteria andSysdateGreaterThan(Date value) {
            addCriterion("SysDate >", value, "sysdate");
            return (Criteria) this;
        }

        public Criteria andSysdateGreaterThanOrEqualTo(Date value) {
            addCriterion("SysDate >=", value, "sysdate");
            return (Criteria) this;
        }

        public Criteria andSysdateLessThan(Date value) {
            addCriterion("SysDate <", value, "sysdate");
            return (Criteria) this;
        }

        public Criteria andSysdateLessThanOrEqualTo(Date value) {
            addCriterion("SysDate <=", value, "sysdate");
            return (Criteria) this;
        }

        public Criteria andSysdateIn(List<Date> values) {
            addCriterion("SysDate in", values, "sysdate");
            return (Criteria) this;
        }

        public Criteria andSysdateNotIn(List<Date> values) {
            addCriterion("SysDate not in", values, "sysdate");
            return (Criteria) this;
        }

        public Criteria andSysdateBetween(Date value1, Date value2) {
            addCriterion("SysDate between", value1, value2, "sysdate");
            return (Criteria) this;
        }

        public Criteria andSysdateNotBetween(Date value1, Date value2) {
            addCriterion("SysDate not between", value1, value2, "sysdate");
            return (Criteria) this;
        }

        public Criteria andOperatorIsNull() {
            addCriterion("Operator is null");
            return (Criteria) this;
        }

        public Criteria andOperatorIsNotNull() {
            addCriterion("Operator is not null");
            return (Criteria) this;
        }

        public Criteria andOperatorEqualTo(String value) {
            addCriterion("Operator =", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorNotEqualTo(String value) {
            addCriterion("Operator <>", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorGreaterThan(String value) {
            addCriterion("Operator >", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorGreaterThanOrEqualTo(String value) {
            addCriterion("Operator >=", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorLessThan(String value) {
            addCriterion("Operator <", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorLessThanOrEqualTo(String value) {
            addCriterion("Operator <=", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorLike(String value) {
            addCriterion("Operator like", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorNotLike(String value) {
            addCriterion("Operator not like", value, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorIn(List<String> values) {
            addCriterion("Operator in", values, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorNotIn(List<String> values) {
            addCriterion("Operator not in", values, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorBetween(String value1, String value2) {
            addCriterion("Operator between", value1, value2, "operator");
            return (Criteria) this;
        }

        public Criteria andOperatorNotBetween(String value1, String value2) {
            addCriterion("Operator not between", value1, value2, "operator");
            return (Criteria) this;
        }

        public Criteria andSynctagIsNull() {
            addCriterion("SyncTag is null");
            return (Criteria) this;
        }

        public Criteria andSynctagIsNotNull() {
            addCriterion("SyncTag is not null");
            return (Criteria) this;
        }

        public Criteria andSynctagEqualTo(String value) {
            addCriterion("SyncTag =", value, "synctag");
            return (Criteria) this;
        }

        public Criteria andSynctagNotEqualTo(String value) {
            addCriterion("SyncTag <>", value, "synctag");
            return (Criteria) this;
        }

        public Criteria andSynctagGreaterThan(String value) {
            addCriterion("SyncTag >", value, "synctag");
            return (Criteria) this;
        }

        public Criteria andSynctagGreaterThanOrEqualTo(String value) {
            addCriterion("SyncTag >=", value, "synctag");
            return (Criteria) this;
        }

        public Criteria andSynctagLessThan(String value) {
            addCriterion("SyncTag <", value, "synctag");
            return (Criteria) this;
        }

        public Criteria andSynctagLessThanOrEqualTo(String value) {
            addCriterion("SyncTag <=", value, "synctag");
            return (Criteria) this;
        }

        public Criteria andSynctagLike(String value) {
            addCriterion("SyncTag like", value, "synctag");
            return (Criteria) this;
        }

        public Criteria andSynctagNotLike(String value) {
            addCriterion("SyncTag not like", value, "synctag");
            return (Criteria) this;
        }

        public Criteria andSynctagIn(List<String> values) {
            addCriterion("SyncTag in", values, "synctag");
            return (Criteria) this;
        }

        public Criteria andSynctagNotIn(List<String> values) {
            addCriterion("SyncTag not in", values, "synctag");
            return (Criteria) this;
        }

        public Criteria andSynctagBetween(String value1, String value2) {
            addCriterion("SyncTag between", value1, value2, "synctag");
            return (Criteria) this;
        }

        public Criteria andSynctagNotBetween(String value1, String value2) {
            addCriterion("SyncTag not between", value1, value2, "synctag");
            return (Criteria) this;
        }

        public Criteria andPromgqtyIsNull() {
            addCriterion("PromGQty is null");
            return (Criteria) this;
        }

        public Criteria andPromgqtyIsNotNull() {
            addCriterion("PromGQty is not null");
            return (Criteria) this;
        }

        public Criteria andPromgqtyEqualTo(BigDecimal value) {
            addCriterion("PromGQty =", value, "promgqty");
            return (Criteria) this;
        }

        public Criteria andPromgqtyNotEqualTo(BigDecimal value) {
            addCriterion("PromGQty <>", value, "promgqty");
            return (Criteria) this;
        }

        public Criteria andPromgqtyGreaterThan(BigDecimal value) {
            addCriterion("PromGQty >", value, "promgqty");
            return (Criteria) this;
        }

        public Criteria andPromgqtyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("PromGQty >=", value, "promgqty");
            return (Criteria) this;
        }

        public Criteria andPromgqtyLessThan(BigDecimal value) {
            addCriterion("PromGQty <", value, "promgqty");
            return (Criteria) this;
        }

        public Criteria andPromgqtyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("PromGQty <=", value, "promgqty");
            return (Criteria) this;
        }

        public Criteria andPromgqtyIn(List<BigDecimal> values) {
            addCriterion("PromGQty in", values, "promgqty");
            return (Criteria) this;
        }

        public Criteria andPromgqtyNotIn(List<BigDecimal> values) {
            addCriterion("PromGQty not in", values, "promgqty");
            return (Criteria) this;
        }

        public Criteria andPromgqtyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PromGQty between", value1, value2, "promgqty");
            return (Criteria) this;
        }

        public Criteria andPromgqtyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PromGQty not between", value1, value2, "promgqty");
            return (Criteria) this;
        }

        public Criteria andR00102cIsNull() {
            addCriterion("R00102c is null");
            return (Criteria) this;
        }

        public Criteria andR00102cIsNotNull() {
            addCriterion("R00102c is not null");
            return (Criteria) this;
        }

        public Criteria andR00102cEqualTo(Integer value) {
            addCriterion("R00102c =", value, "r00102c");
            return (Criteria) this;
        }

        public Criteria andR00102cNotEqualTo(Integer value) {
            addCriterion("R00102c <>", value, "r00102c");
            return (Criteria) this;
        }

        public Criteria andR00102cGreaterThan(Integer value) {
            addCriterion("R00102c >", value, "r00102c");
            return (Criteria) this;
        }

        public Criteria andR00102cGreaterThanOrEqualTo(Integer value) {
            addCriterion("R00102c >=", value, "r00102c");
            return (Criteria) this;
        }

        public Criteria andR00102cLessThan(Integer value) {
            addCriterion("R00102c <", value, "r00102c");
            return (Criteria) this;
        }

        public Criteria andR00102cLessThanOrEqualTo(Integer value) {
            addCriterion("R00102c <=", value, "r00102c");
            return (Criteria) this;
        }

        public Criteria andR00102cIn(List<Integer> values) {
            addCriterion("R00102c in", values, "r00102c");
            return (Criteria) this;
        }

        public Criteria andR00102cNotIn(List<Integer> values) {
            addCriterion("R00102c not in", values, "r00102c");
            return (Criteria) this;
        }

        public Criteria andR00102cBetween(Integer value1, Integer value2) {
            addCriterion("R00102c between", value1, value2, "r00102c");
            return (Criteria) this;
        }

        public Criteria andR00102cNotBetween(Integer value1, Integer value2) {
            addCriterion("R00102c not between", value1, value2, "r00102c");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}